www.gusucode.com > XerCMS 携云PHP企业建站程序 v2015PHP源码程序 > XerCMS 携云PHP企业建站程序 v2015/XerCMS_v20150724/XerCMS_v20150724/XerCMS/Utils/tables/XerCMS_forum.php

    <?php
/**
 * @name     XERCMS
 * @author   Arno <XerCMS@163.com> [QQ:1328013]
 * @version  1.0.0
 * @link     http://www.XerCMS.com
 */

!defined('XERCMS') && exit('Access Denied');

class TABLE_forum extends resource
{
     private $data = NULL;
     private $defaultTable = 'xercms_forum';
	 
	function __construct() {
	 	$this->table = $this->defaultTable;
	} 
 
     function delboard($bid) { 
	     return DB::query('DELETE FROM xercms_forum_board WHERE bid = '.(int)$bid);
	}
	
     function board_count($parent = null) { 
	     return DB::result_first('SELECT count(*) FROM xercms_forum_board'.($parent === null ? '' :  ' WHERE parent = '.(int)$parent));
	}
 
     function posts($page,$number = 30,$uid = 0) {    
		$uid = empty($uid) ? X::$G['uid'] : $uid;
		return DB::fetch_all('SELECT t.*,p.*,m.nick FROM xercms_forum_topic t,xercms_forum_posts p,xercms_member_profile m WHERE t.tid = p.tid and t.uid = m.uid and m.uid = p.uid and p.uid = '.X::$G['uid'].' group by p.uid  limit '.(($page-1)*$number).','.$number);
	}

     function topic($page,$number = 30,$uid = 0) {     
		$uid = empty($uid) ? X::$G['uid'] : $uid;
		return DB::fetch_all('SELECT t.*,m.nick FROM xercms_forum_topic t,xercms_member_profile m WHERE m.uid = t.uid and t.uid = '.X::$G['uid'].' limit '.(($page-1)*$number).','.$number);
	}

	function count($field ,$uid = 0) {   
		$uid = empty($uid) ? X::$G['uid'] : $uid;
	     return DB::result_first('SELECT '.$field.' FROM xercms_member_count WHERE uid = '.X::$G['uid']);
	}
}
?>